package com.qf.dao;


import com.qf.assetsappraisal.Assetsappraisal;
import org.springframework.data.jpa.repository.JpaRepository;


import java.util.List;

public interface AssetsappraisalDao extends JpaRepository<Assetsappraisal, Integer> {
    //申请单id查一个
   /* Assetsappraisal findByBorrowerId(Integer borrowerId);*/

    //申请单id查多个
    //List<Assetsappraisal> findAllByBorrowerId(Integer borrowerId);


    //申请单id和证的模糊查
    List<Assetsappraisal> findByBorrowerIdOrCertificateNameContaining(Integer borrowerId,String certificateName);
    //申请单id查多个
    List<Assetsappraisal> findAllByBorrowerId(Integer borrowerId);
//    Assetsappraisal findById( Integer Id);

    //Assetsappraisal saveOrUpdateByBorrowerId(Integer borrowerId);
}
